package org.jetnuke.modules.reviews;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.velocity.VelocityContext;
import org.jetnuke.common.ActionForward;
import org.jetnuke.common.IAction;
import org.jetnuke.common.IAdminInfo;
import org.jetnuke.common.IModuleInfo;
import org.jetnuke.common.IUserInfo;
import org.jetnuke.dao.DataAccessDriver;
import org.jetnuke.dao.ReviewsDAO;

public class Reviews implements IAction {

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.jetnuke.common.IAction#exec(javax.servlet.http.HttpServletRequest,
	 *      javax.servlet.http.HttpServletResponse,
	 *      org.apache.velocity.VelocityContext, org.jetnuke.common.IModuleInfo,
	 *      java.lang.String, int)
	 */
	public ActionForward exec(HttpServletRequest request,
			HttpServletResponse response, VelocityContext vc, IModuleInfo info,
			String op, IUserInfo ui, IAdminInfo ai) throws Exception {
		ReviewsDAO rm=DataAccessDriver.getInst().newReviewsDAO();
		vc.put("top_hits",rm.selectOrderHitsDesc(10));// reviewsPeer.doSelect(new Criteria()
				//.addDescendingOrderByColumn(reviewsPeer.HITS).setLimit(10)));
		vc.put("top_date", rm.selectOrderDateDesc(10));//reviewsPeer.doSelect(new Criteria()
				//.addDescendingOrderByColumn(reviewsPeer.DATE).setLimit(10)));
		return new ActionForward(op, info);
	}

}
